from openpyxl import load_workbook


class read_excel():

    def __init__(self, filepath, sheetname):
        self.workbook = load_workbook(filepath)
        self.wb = self.workbook[sheetname]

    def read(self):
        datalist = []
        for item in self.wb:
            list = []
            list.append(item[0].value)
            list.append(item[2].value)
            list.append(item[5].value)
            list.append(item[6].value)
            list.append(item[7].value)
            datalist.append(list)

        datalist.pop(0)
        return datalist


# tt = read_excel(r'./login.xlsx', 'Sheet1')
# print(tt.read())






